This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
RE: How to get 7 values out of more than 2'000'000 documents ~Lorraine Desgerothernivu 2.Dec.03 10:22 PM a Web browser Applications Development 6.0.2 CF2Windows 2000
So I am a little bit further now.
To clear the situation a little bit:
The documents in the log database contain a field 'Username'. This field is simple made up of a String like 'Christian Schuster' and is used to identify to whom the log document belongs.
For each user exists two documents. One is in the the public address book for athentication. The other one is in another database. This document contains specific information about the user which is needed to run the web app.
Until now there was no need for this category as said, thus, not any IT who was developing this app has thought about this before. In a way a little bit sad because it would not have hurt at all to store the categories, a user is using, in his specific document.
Anyway, I created a view with two columns the first is the user name and the second the category. The second column is categorized. To build the view index took about three hours which is even not so terrible.
Then I wrote an agent which gets this view and gets all documents by key which was quite fast. This way I have already all values which I need. Those values I save then in the users specific document.
This way the agent needs just 25 mins to process 1000 users. So, at the end I will need around 1h15min to process one database including the build time of the view around 4h15min for a database. By around 20dbs I will need about 100h. With this solution I can live, although the size of the view is huge(800MB). But at the end I can delete this view again.
A final word:
I appreciated all the nice help here which gave me some really good tips how to do it. I also try as far as I can to help other people. But I for sure NEVER NEVER NEVER write that something is not possible. This is just soooo stupid. We are here to help each other, thus, just constructive comments are welcome!!!
Also, we are using now domino and we cannot just move the whole web app into another system which would need much more time to move and set up than the solution now!!!
Return to top
. . . . RE: How to get 7 values out of more... (~Lorraine Desge... 2.Dec.03) 
Print this page
